home *** CD-ROM | disk | FTP | other *** search

---

/ Developer Source 7 / developer source - volume 7.iso / delpp / fig18-07.gif

< prev

next >

Graphics Interchange Format  |  1996-11-19  |  13KB  |  593x454  |  4-bit (10 colors)

Labels: text | electronics | screenshot | display | software | number
OCR: +++ A [ab] OK x Form1.Query1 x SQL Demo Setting SQL through code to display Orders where Items Total > $50,000 OR belong to Customer # 1351 Run CustNo OrderNo Items Total SQL: Select CustNo, OrderNo, A 1351 1003 $1,250.00 ItemsTotal From Orders Where ItemsTotal > 50000 OR CustNo = 1351 5515 1044 $64,050.00 1351 1052 $16,788.00 1351 1055 $23,406.00 3042 1063 $61,869.30 1351 1067 $4,495.00 1560 1071 $103,041.00 1351 1075 $8,560.00 3041 1078 $79,116.00 Title /SQL(1) SQL(2) SQL(3) SQL(4) SQL(5) SQL(6) SQL(7) SQL(8) SQL(9) SQL(10) SQL(11) SQL(12)

---